IF EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[GetCOIHierarchyTypes]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)
BEGIN
	DROP PROCEDURE dbo.GetCOIHierarchyTypes
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

/******************************************************************
*  Name:  GetCOIHierarchyTypes
* Purpose:  Procedure to get the COI Hierarchy Types
*****************************************************************/

CREATE PROCEDURE [dbo].[GetCOIHierarchyTypes]
AS
BEGIN

	SELECT Id,Description
	FROM 
		COIHierarchyType

END

--Exec [GetCOIHierarchyTypes]


 